﻿CREATE TABLE [dbo].[TelefonosProveedores] (
    [IdTelefonoProveedor] INT          IDENTITY (1, 1) NOT NULL,
    [IdTipoTelefono]      TINYINT      NOT NULL,
    [IdProveedor]         INT          NOT NULL,
    [CodigoArea]          VARCHAR (5)  NOT NULL,
    [Numero]              VARCHAR (10) NOT NULL,
    CONSTRAINT [PK_TelefonosProveedores] PRIMARY KEY CLUSTERED ([IdTelefonoProveedor] ASC),
    CONSTRAINT [FK_TelefonosProveedores_Proveedores] FOREIGN KEY ([IdProveedor]) REFERENCES [dbo].[Proveedores] ([IdProveedor]),
    CONSTRAINT [FK_TelefonosProveedores_TiposTelefonos] FOREIGN KEY ([IdTipoTelefono]) REFERENCES [dbo].[TiposTelefonos] ([IdTipoTelefono])
);

